/**
 * @mbggenerated
 * @author kehui
 */
package com.mall.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MallGroupBuyExample extends BaseExample {
    /* @mbggenerated */
    protected String orderByClause;

    /* @mbggenerated */
    protected boolean distinct;

    /* @mbggenerated */
    protected List<Criteria> oredCriteria;

    /* @mbggenerated */
    public MallGroupBuyExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /* @mbggenerated */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /* @mbggenerated */
    public String getOrderByClause() {
        return orderByClause;
    }

    /* @mbggenerated */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /* @mbggenerated */
    public boolean isDistinct() {
        return distinct;
    }

    /* @mbggenerated */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /* @mbggenerated */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /* @mbggenerated */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /* @mbggenerated */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /* @mbggenerated */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /* @mbggenerated */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * 对应数据库表 mall_group_buy
     *
     * @mbggenerated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andMallIdIsNull() {
            addCriterion("mall_id is null");
            return (Criteria) this;
        }

        public Criteria andMallIdIsNotNull() {
            addCriterion("mall_id is not null");
            return (Criteria) this;
        }

        public Criteria andMallIdEqualTo(Long value) {
            addCriterion("mall_id =", value, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdNotEqualTo(Long value) {
            addCriterion("mall_id <>", value, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdGreaterThan(Long value) {
            addCriterion("mall_id >", value, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdGreaterThanOrEqualTo(Long value) {
            addCriterion("mall_id >=", value, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdLessThan(Long value) {
            addCriterion("mall_id <", value, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdLessThanOrEqualTo(Long value) {
            addCriterion("mall_id <=", value, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdIn(List<Long> values) {
            addCriterion("mall_id in", values, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdNotIn(List<Long> values) {
            addCriterion("mall_id not in", values, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdBetween(Long value1, Long value2) {
            addCriterion("mall_id between", value1, value2, "mallId");
            return (Criteria) this;
        }

        public Criteria andMallIdNotBetween(Long value1, Long value2) {
            addCriterion("mall_id not between", value1, value2, "mallId");
            return (Criteria) this;
        }

        public Criteria andTitleIsNull() {
            addCriterion("title is null");
            return (Criteria) this;
        }

        public Criteria andTitleIsNotNull() {
            addCriterion("title is not null");
            return (Criteria) this;
        }

        public Criteria andTitleEqualTo(String value) {
            addCriterion("title =", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotEqualTo(String value) {
            addCriterion("title <>", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThan(String value) {
            addCriterion("title >", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThanOrEqualTo(String value) {
            addCriterion("title >=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThan(String value) {
            addCriterion("title <", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThanOrEqualTo(String value) {
            addCriterion("title <=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLike(String value) {
            addCriterion("title like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotLike(String value) {
            addCriterion("title not like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleIn(List<String> values) {
            addCriterion("title in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotIn(List<String> values) {
            addCriterion("title not in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleBetween(String value1, String value2) {
            addCriterion("title between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotBetween(String value1, String value2) {
            addCriterion("title not between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andPyNameIsNull() {
            addCriterion("py_name is null");
            return (Criteria) this;
        }

        public Criteria andPyNameIsNotNull() {
            addCriterion("py_name is not null");
            return (Criteria) this;
        }

        public Criteria andPyNameEqualTo(String value) {
            addCriterion("py_name =", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameNotEqualTo(String value) {
            addCriterion("py_name <>", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameGreaterThan(String value) {
            addCriterion("py_name >", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameGreaterThanOrEqualTo(String value) {
            addCriterion("py_name >=", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameLessThan(String value) {
            addCriterion("py_name <", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameLessThanOrEqualTo(String value) {
            addCriterion("py_name <=", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameLike(String value) {
            addCriterion("py_name like", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameNotLike(String value) {
            addCriterion("py_name not like", value, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameIn(List<String> values) {
            addCriterion("py_name in", values, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameNotIn(List<String> values) {
            addCriterion("py_name not in", values, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameBetween(String value1, String value2) {
            addCriterion("py_name between", value1, value2, "pyName");
            return (Criteria) this;
        }

        public Criteria andPyNameNotBetween(String value1, String value2) {
            addCriterion("py_name not between", value1, value2, "pyName");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(Long value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(Long value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(Long value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(Long value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(Long value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(Long value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<Long> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<Long> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(Long value1, Long value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(Long value1, Long value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andTuanDescIsNull() {
            addCriterion("tuan_desc is null");
            return (Criteria) this;
        }

        public Criteria andTuanDescIsNotNull() {
            addCriterion("tuan_desc is not null");
            return (Criteria) this;
        }

        public Criteria andTuanDescEqualTo(String value) {
            addCriterion("tuan_desc =", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescNotEqualTo(String value) {
            addCriterion("tuan_desc <>", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescGreaterThan(String value) {
            addCriterion("tuan_desc >", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescGreaterThanOrEqualTo(String value) {
            addCriterion("tuan_desc >=", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescLessThan(String value) {
            addCriterion("tuan_desc <", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescLessThanOrEqualTo(String value) {
            addCriterion("tuan_desc <=", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescLike(String value) {
            addCriterion("tuan_desc like", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescNotLike(String value) {
            addCriterion("tuan_desc not like", value, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescIn(List<String> values) {
            addCriterion("tuan_desc in", values, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescNotIn(List<String> values) {
            addCriterion("tuan_desc not in", values, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescBetween(String value1, String value2) {
            addCriterion("tuan_desc between", value1, value2, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andTuanDescNotBetween(String value1, String value2) {
            addCriterion("tuan_desc not between", value1, value2, "tuanDesc");
            return (Criteria) this;
        }

        public Criteria andMainPicIsNull() {
            addCriterion("main_pic is null");
            return (Criteria) this;
        }

        public Criteria andMainPicIsNotNull() {
            addCriterion("main_pic is not null");
            return (Criteria) this;
        }

        public Criteria andMainPicEqualTo(String value) {
            addCriterion("main_pic =", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicNotEqualTo(String value) {
            addCriterion("main_pic <>", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicGreaterThan(String value) {
            addCriterion("main_pic >", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicGreaterThanOrEqualTo(String value) {
            addCriterion("main_pic >=", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicLessThan(String value) {
            addCriterion("main_pic <", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicLessThanOrEqualTo(String value) {
            addCriterion("main_pic <=", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicLike(String value) {
            addCriterion("main_pic like", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicNotLike(String value) {
            addCriterion("main_pic not like", value, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicIn(List<String> values) {
            addCriterion("main_pic in", values, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicNotIn(List<String> values) {
            addCriterion("main_pic not in", values, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicBetween(String value1, String value2) {
            addCriterion("main_pic between", value1, value2, "mainPic");
            return (Criteria) this;
        }

        public Criteria andMainPicNotBetween(String value1, String value2) {
            addCriterion("main_pic not between", value1, value2, "mainPic");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceIsNull() {
            addCriterion("original_price is null");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceIsNotNull() {
            addCriterion("original_price is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceEqualTo(Long value) {
            addCriterion("original_price =", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceNotEqualTo(Long value) {
            addCriterion("original_price <>", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceGreaterThan(Long value) {
            addCriterion("original_price >", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceGreaterThanOrEqualTo(Long value) {
            addCriterion("original_price >=", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceLessThan(Long value) {
            addCriterion("original_price <", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceLessThanOrEqualTo(Long value) {
            addCriterion("original_price <=", value, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceIn(List<Long> values) {
            addCriterion("original_price in", values, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceNotIn(List<Long> values) {
            addCriterion("original_price not in", values, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceBetween(Long value1, Long value2) {
            addCriterion("original_price between", value1, value2, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andOriginalPriceNotBetween(Long value1, Long value2) {
            addCriterion("original_price not between", value1, value2, "originalPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNull() {
            addCriterion("discount_price is null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNotNull() {
            addCriterion("discount_price is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceEqualTo(Long value) {
            addCriterion("discount_price =", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotEqualTo(Long value) {
            addCriterion("discount_price <>", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThan(Long value) {
            addCriterion("discount_price >", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanOrEqualTo(Long value) {
            addCriterion("discount_price >=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThan(Long value) {
            addCriterion("discount_price <", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanOrEqualTo(Long value) {
            addCriterion("discount_price <=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIn(List<Long> values) {
            addCriterion("discount_price in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotIn(List<Long> values) {
            addCriterion("discount_price not in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceBetween(Long value1, Long value2) {
            addCriterion("discount_price between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotBetween(Long value1, Long value2) {
            addCriterion("discount_price not between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andSaleNoIsNull() {
            addCriterion("sale_no is null");
            return (Criteria) this;
        }

        public Criteria andSaleNoIsNotNull() {
            addCriterion("sale_no is not null");
            return (Criteria) this;
        }

        public Criteria andSaleNoEqualTo(Long value) {
            addCriterion("sale_no =", value, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoNotEqualTo(Long value) {
            addCriterion("sale_no <>", value, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoGreaterThan(Long value) {
            addCriterion("sale_no >", value, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoGreaterThanOrEqualTo(Long value) {
            addCriterion("sale_no >=", value, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoLessThan(Long value) {
            addCriterion("sale_no <", value, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoLessThanOrEqualTo(Long value) {
            addCriterion("sale_no <=", value, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoIn(List<Long> values) {
            addCriterion("sale_no in", values, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoNotIn(List<Long> values) {
            addCriterion("sale_no not in", values, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoBetween(Long value1, Long value2) {
            addCriterion("sale_no between", value1, value2, "saleNo");
            return (Criteria) this;
        }

        public Criteria andSaleNoNotBetween(Long value1, Long value2) {
            addCriterion("sale_no not between", value1, value2, "saleNo");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIsNull() {
            addCriterion("expiry_date is null");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIsNotNull() {
            addCriterion("expiry_date is not null");
            return (Criteria) this;
        }

        public Criteria andExpiryDateEqualTo(String value) {
            addCriterion("expiry_date =", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotEqualTo(String value) {
            addCriterion("expiry_date <>", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateGreaterThan(String value) {
            addCriterion("expiry_date >", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateGreaterThanOrEqualTo(String value) {
            addCriterion("expiry_date >=", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLessThan(String value) {
            addCriterion("expiry_date <", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLessThanOrEqualTo(String value) {
            addCriterion("expiry_date <=", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLike(String value) {
            addCriterion("expiry_date like", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotLike(String value) {
            addCriterion("expiry_date not like", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIn(List<String> values) {
            addCriterion("expiry_date in", values, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotIn(List<String> values) {
            addCriterion("expiry_date not in", values, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateBetween(String value1, String value2) {
            addCriterion("expiry_date between", value1, value2, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotBetween(String value1, String value2) {
            addCriterion("expiry_date not between", value1, value2, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateIsNull() {
            addCriterion("exception_date is null");
            return (Criteria) this;
        }

        public Criteria andExceptionDateIsNotNull() {
            addCriterion("exception_date is not null");
            return (Criteria) this;
        }

        public Criteria andExceptionDateEqualTo(String value) {
            addCriterion("exception_date =", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateNotEqualTo(String value) {
            addCriterion("exception_date <>", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateGreaterThan(String value) {
            addCriterion("exception_date >", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateGreaterThanOrEqualTo(String value) {
            addCriterion("exception_date >=", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateLessThan(String value) {
            addCriterion("exception_date <", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateLessThanOrEqualTo(String value) {
            addCriterion("exception_date <=", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateLike(String value) {
            addCriterion("exception_date like", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateNotLike(String value) {
            addCriterion("exception_date not like", value, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateIn(List<String> values) {
            addCriterion("exception_date in", values, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateNotIn(List<String> values) {
            addCriterion("exception_date not in", values, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateBetween(String value1, String value2) {
            addCriterion("exception_date between", value1, value2, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andExceptionDateNotBetween(String value1, String value2) {
            addCriterion("exception_date not between", value1, value2, "exceptionDate");
            return (Criteria) this;
        }

        public Criteria andUseTimeIsNull() {
            addCriterion("use_time is null");
            return (Criteria) this;
        }

        public Criteria andUseTimeIsNotNull() {
            addCriterion("use_time is not null");
            return (Criteria) this;
        }

        public Criteria andUseTimeEqualTo(String value) {
            addCriterion("use_time =", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotEqualTo(String value) {
            addCriterion("use_time <>", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThan(String value) {
            addCriterion("use_time >", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThanOrEqualTo(String value) {
            addCriterion("use_time >=", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThan(String value) {
            addCriterion("use_time <", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThanOrEqualTo(String value) {
            addCriterion("use_time <=", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeLike(String value) {
            addCriterion("use_time like", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotLike(String value) {
            addCriterion("use_time not like", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeIn(List<String> values) {
            addCriterion("use_time in", values, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotIn(List<String> values) {
            addCriterion("use_time not in", values, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeBetween(String value1, String value2) {
            addCriterion("use_time between", value1, value2, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotBetween(String value1, String value2) {
            addCriterion("use_time not between", value1, value2, "useTime");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingIsNull() {
            addCriterion("yuyue_tixing is null");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingIsNotNull() {
            addCriterion("yuyue_tixing is not null");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingEqualTo(String value) {
            addCriterion("yuyue_tixing =", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingNotEqualTo(String value) {
            addCriterion("yuyue_tixing <>", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingGreaterThan(String value) {
            addCriterion("yuyue_tixing >", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingGreaterThanOrEqualTo(String value) {
            addCriterion("yuyue_tixing >=", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingLessThan(String value) {
            addCriterion("yuyue_tixing <", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingLessThanOrEqualTo(String value) {
            addCriterion("yuyue_tixing <=", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingLike(String value) {
            addCriterion("yuyue_tixing like", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingNotLike(String value) {
            addCriterion("yuyue_tixing not like", value, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingIn(List<String> values) {
            addCriterion("yuyue_tixing in", values, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingNotIn(List<String> values) {
            addCriterion("yuyue_tixing not in", values, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingBetween(String value1, String value2) {
            addCriterion("yuyue_tixing between", value1, value2, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andYuyueTixingNotBetween(String value1, String value2) {
            addCriterion("yuyue_tixing not between", value1, value2, "yuyueTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingIsNull() {
            addCriterion("guize_tixing is null");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingIsNotNull() {
            addCriterion("guize_tixing is not null");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingEqualTo(String value) {
            addCriterion("guize_tixing =", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingNotEqualTo(String value) {
            addCriterion("guize_tixing <>", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingGreaterThan(String value) {
            addCriterion("guize_tixing >", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingGreaterThanOrEqualTo(String value) {
            addCriterion("guize_tixing >=", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingLessThan(String value) {
            addCriterion("guize_tixing <", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingLessThanOrEqualTo(String value) {
            addCriterion("guize_tixing <=", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingLike(String value) {
            addCriterion("guize_tixing like", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingNotLike(String value) {
            addCriterion("guize_tixing not like", value, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingIn(List<String> values) {
            addCriterion("guize_tixing in", values, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingNotIn(List<String> values) {
            addCriterion("guize_tixing not in", values, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingBetween(String value1, String value2) {
            addCriterion("guize_tixing between", value1, value2, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andGuizeTixingNotBetween(String value1, String value2) {
            addCriterion("guize_tixing not between", value1, value2, "guizeTixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingIsNull() {
            addCriterion("wenxingtixing is null");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingIsNotNull() {
            addCriterion("wenxingtixing is not null");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingEqualTo(String value) {
            addCriterion("wenxingtixing =", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingNotEqualTo(String value) {
            addCriterion("wenxingtixing <>", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingGreaterThan(String value) {
            addCriterion("wenxingtixing >", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingGreaterThanOrEqualTo(String value) {
            addCriterion("wenxingtixing >=", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingLessThan(String value) {
            addCriterion("wenxingtixing <", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingLessThanOrEqualTo(String value) {
            addCriterion("wenxingtixing <=", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingLike(String value) {
            addCriterion("wenxingtixing like", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingNotLike(String value) {
            addCriterion("wenxingtixing not like", value, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingIn(List<String> values) {
            addCriterion("wenxingtixing in", values, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingNotIn(List<String> values) {
            addCriterion("wenxingtixing not in", values, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingBetween(String value1, String value2) {
            addCriterion("wenxingtixing between", value1, value2, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andWenxingtixingNotBetween(String value1, String value2) {
            addCriterion("wenxingtixing not between", value1, value2, "wenxingtixing");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuIsNull() {
            addCriterion("shangjiafuwu is null");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuIsNotNull() {
            addCriterion("shangjiafuwu is not null");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuEqualTo(String value) {
            addCriterion("shangjiafuwu =", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuNotEqualTo(String value) {
            addCriterion("shangjiafuwu <>", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuGreaterThan(String value) {
            addCriterion("shangjiafuwu >", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuGreaterThanOrEqualTo(String value) {
            addCriterion("shangjiafuwu >=", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuLessThan(String value) {
            addCriterion("shangjiafuwu <", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuLessThanOrEqualTo(String value) {
            addCriterion("shangjiafuwu <=", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuLike(String value) {
            addCriterion("shangjiafuwu like", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuNotLike(String value) {
            addCriterion("shangjiafuwu not like", value, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuIn(List<String> values) {
            addCriterion("shangjiafuwu in", values, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuNotIn(List<String> values) {
            addCriterion("shangjiafuwu not in", values, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuBetween(String value1, String value2) {
            addCriterion("shangjiafuwu between", value1, value2, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andShangjiafuwuNotBetween(String value1, String value2) {
            addCriterion("shangjiafuwu not between", value1, value2, "shangjiafuwu");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingIsNull() {
            addCriterion("tuigaishuoming is null");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingIsNotNull() {
            addCriterion("tuigaishuoming is not null");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingEqualTo(String value) {
            addCriterion("tuigaishuoming =", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingNotEqualTo(String value) {
            addCriterion("tuigaishuoming <>", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingGreaterThan(String value) {
            addCriterion("tuigaishuoming >", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingGreaterThanOrEqualTo(String value) {
            addCriterion("tuigaishuoming >=", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingLessThan(String value) {
            addCriterion("tuigaishuoming <", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingLessThanOrEqualTo(String value) {
            addCriterion("tuigaishuoming <=", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingLike(String value) {
            addCriterion("tuigaishuoming like", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingNotLike(String value) {
            addCriterion("tuigaishuoming not like", value, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingIn(List<String> values) {
            addCriterion("tuigaishuoming in", values, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingNotIn(List<String> values) {
            addCriterion("tuigaishuoming not in", values, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingBetween(String value1, String value2) {
            addCriterion("tuigaishuoming between", value1, value2, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTuigaishuomingNotBetween(String value1, String value2) {
            addCriterion("tuigaishuoming not between", value1, value2, "tuigaishuoming");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionIsNull() {
            addCriterion("simple_description is null");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionIsNotNull() {
            addCriterion("simple_description is not null");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionEqualTo(String value) {
            addCriterion("simple_description =", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionNotEqualTo(String value) {
            addCriterion("simple_description <>", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionGreaterThan(String value) {
            addCriterion("simple_description >", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("simple_description >=", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionLessThan(String value) {
            addCriterion("simple_description <", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionLessThanOrEqualTo(String value) {
            addCriterion("simple_description <=", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionLike(String value) {
            addCriterion("simple_description like", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionNotLike(String value) {
            addCriterion("simple_description not like", value, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionIn(List<String> values) {
            addCriterion("simple_description in", values, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionNotIn(List<String> values) {
            addCriterion("simple_description not in", values, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionBetween(String value1, String value2) {
            addCriterion("simple_description between", value1, value2, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andSimpleDescriptionNotBetween(String value1, String value2) {
            addCriterion("simple_description not between", value1, value2, "simpleDescription");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNull() {
            addCriterion("category_id is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNotNull() {
            addCriterion("category_id is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdEqualTo(Integer value) {
            addCriterion("category_id =", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotEqualTo(Integer value) {
            addCriterion("category_id <>", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThan(Integer value) {
            addCriterion("category_id >", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("category_id >=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThan(Integer value) {
            addCriterion("category_id <", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanOrEqualTo(Integer value) {
            addCriterion("category_id <=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIn(List<Integer> values) {
            addCriterion("category_id in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotIn(List<Integer> values) {
            addCriterion("category_id not in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdBetween(Integer value1, Integer value2) {
            addCriterion("category_id between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("category_id not between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(Date value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(Date value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(Date value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(Date value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<Date> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<Date> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(Date value1, Date value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifyIsNull() {
            addCriterion("gmt_modify is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifyIsNotNull() {
            addCriterion("gmt_modify is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifyEqualTo(Date value) {
            addCriterion("gmt_modify =", value, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyNotEqualTo(Date value) {
            addCriterion("gmt_modify <>", value, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyGreaterThan(Date value) {
            addCriterion("gmt_modify >", value, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_modify >=", value, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyLessThan(Date value) {
            addCriterion("gmt_modify <", value, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyLessThanOrEqualTo(Date value) {
            addCriterion("gmt_modify <=", value, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyIn(List<Date> values) {
            addCriterion("gmt_modify in", values, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyNotIn(List<Date> values) {
            addCriterion("gmt_modify not in", values, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyBetween(Date value1, Date value2) {
            addCriterion("gmt_modify between", value1, value2, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andGmtModifyNotBetween(Date value1, Date value2) {
            addCriterion("gmt_modify not between", value1, value2, "gmtModify");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdIsNull() {
            addCriterion("sec_category_id is null");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdIsNotNull() {
            addCriterion("sec_category_id is not null");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdEqualTo(Integer value) {
            addCriterion("sec_category_id =", value, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdNotEqualTo(Integer value) {
            addCriterion("sec_category_id <>", value, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdGreaterThan(Integer value) {
            addCriterion("sec_category_id >", value, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("sec_category_id >=", value, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdLessThan(Integer value) {
            addCriterion("sec_category_id <", value, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdLessThanOrEqualTo(Integer value) {
            addCriterion("sec_category_id <=", value, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdIn(List<Integer> values) {
            addCriterion("sec_category_id in", values, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdNotIn(List<Integer> values) {
            addCriterion("sec_category_id not in", values, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdBetween(Integer value1, Integer value2) {
            addCriterion("sec_category_id between", value1, value2, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andSecCategoryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("sec_category_id not between", value1, value2, "secCategoryId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNull() {
            addCriterion("create_user_id is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNotNull() {
            addCriterion("create_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdEqualTo(Long value) {
            addCriterion("create_user_id =", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotEqualTo(Long value) {
            addCriterion("create_user_id <>", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThan(Long value) {
            addCriterion("create_user_id >", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("create_user_id >=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThan(Long value) {
            addCriterion("create_user_id <", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThanOrEqualTo(Long value) {
            addCriterion("create_user_id <=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIn(List<Long> values) {
            addCriterion("create_user_id in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotIn(List<Long> values) {
            addCriterion("create_user_id not in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdBetween(Long value1, Long value2) {
            addCriterion("create_user_id between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotBetween(Long value1, Long value2) {
            addCriterion("create_user_id not between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andAttributeIsNull() {
            addCriterion("attribute is null");
            return (Criteria) this;
        }

        public Criteria andAttributeIsNotNull() {
            addCriterion("attribute is not null");
            return (Criteria) this;
        }

        public Criteria andAttributeEqualTo(String value) {
            addCriterion("attribute =", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotEqualTo(String value) {
            addCriterion("attribute <>", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeGreaterThan(String value) {
            addCriterion("attribute >", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeGreaterThanOrEqualTo(String value) {
            addCriterion("attribute >=", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeLessThan(String value) {
            addCriterion("attribute <", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeLessThanOrEqualTo(String value) {
            addCriterion("attribute <=", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeLike(String value) {
            addCriterion("attribute like", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotLike(String value) {
            addCriterion("attribute not like", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeIn(List<String> values) {
            addCriterion("attribute in", values, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotIn(List<String> values) {
            addCriterion("attribute not in", values, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeBetween(String value1, String value2) {
            addCriterion("attribute between", value1, value2, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotBetween(String value1, String value2) {
            addCriterion("attribute not between", value1, value2, "attribute");
            return (Criteria) this;
        }

        public Criteria andBiaoqianIsNull() {
            addCriterion("biaoqian is null");
            return (Criteria) this;
        }

        public Criteria andBiaoqianIsNotNull() {
            addCriterion("biaoqian is not null");
            return (Criteria) this;
        }

        public Criteria andBiaoqianEqualTo(String value) {
            addCriterion("biaoqian =", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianNotEqualTo(String value) {
            addCriterion("biaoqian <>", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianGreaterThan(String value) {
            addCriterion("biaoqian >", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianGreaterThanOrEqualTo(String value) {
            addCriterion("biaoqian >=", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianLessThan(String value) {
            addCriterion("biaoqian <", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianLessThanOrEqualTo(String value) {
            addCriterion("biaoqian <=", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianLike(String value) {
            addCriterion("biaoqian like", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianNotLike(String value) {
            addCriterion("biaoqian not like", value, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianIn(List<String> values) {
            addCriterion("biaoqian in", values, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianNotIn(List<String> values) {
            addCriterion("biaoqian not in", values, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianBetween(String value1, String value2) {
            addCriterion("biaoqian between", value1, value2, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andBiaoqianNotBetween(String value1, String value2) {
            addCriterion("biaoqian not between", value1, value2, "biaoqian");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonIsNull() {
            addCriterion("other_mess_json is null");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonIsNotNull() {
            addCriterion("other_mess_json is not null");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonEqualTo(String value) {
            addCriterion("other_mess_json =", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonNotEqualTo(String value) {
            addCriterion("other_mess_json <>", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonGreaterThan(String value) {
            addCriterion("other_mess_json >", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonGreaterThanOrEqualTo(String value) {
            addCriterion("other_mess_json >=", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonLessThan(String value) {
            addCriterion("other_mess_json <", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonLessThanOrEqualTo(String value) {
            addCriterion("other_mess_json <=", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonLike(String value) {
            addCriterion("other_mess_json like", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonNotLike(String value) {
            addCriterion("other_mess_json not like", value, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonIn(List<String> values) {
            addCriterion("other_mess_json in", values, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonNotIn(List<String> values) {
            addCriterion("other_mess_json not in", values, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonBetween(String value1, String value2) {
            addCriterion("other_mess_json between", value1, value2, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andOtherMessJsonNotBetween(String value1, String value2) {
            addCriterion("other_mess_json not between", value1, value2, "otherMessJson");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyIsNull() {
            addCriterion("comm_only_key is null");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyIsNotNull() {
            addCriterion("comm_only_key is not null");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyEqualTo(Integer value) {
            addCriterion("comm_only_key =", value, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyNotEqualTo(Integer value) {
            addCriterion("comm_only_key <>", value, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyGreaterThan(Integer value) {
            addCriterion("comm_only_key >", value, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyGreaterThanOrEqualTo(Integer value) {
            addCriterion("comm_only_key >=", value, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyLessThan(Integer value) {
            addCriterion("comm_only_key <", value, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyLessThanOrEqualTo(Integer value) {
            addCriterion("comm_only_key <=", value, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyIn(List<Integer> values) {
            addCriterion("comm_only_key in", values, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyNotIn(List<Integer> values) {
            addCriterion("comm_only_key not in", values, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyBetween(Integer value1, Integer value2) {
            addCriterion("comm_only_key between", value1, value2, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andCommOnlyKeyNotBetween(Integer value1, Integer value2) {
            addCriterion("comm_only_key not between", value1, value2, "commOnlyKey");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNull() {
            addCriterion("province_id is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNotNull() {
            addCriterion("province_id is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdEqualTo(Integer value) {
            addCriterion("province_id =", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotEqualTo(Integer value) {
            addCriterion("province_id <>", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThan(Integer value) {
            addCriterion("province_id >", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("province_id >=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThan(Integer value) {
            addCriterion("province_id <", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThanOrEqualTo(Integer value) {
            addCriterion("province_id <=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIn(List<Integer> values) {
            addCriterion("province_id in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotIn(List<Integer> values) {
            addCriterion("province_id not in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdBetween(Integer value1, Integer value2) {
            addCriterion("province_id between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("province_id not between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNull() {
            addCriterion("city_id is null");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNotNull() {
            addCriterion("city_id is not null");
            return (Criteria) this;
        }

        public Criteria andCityIdEqualTo(Integer value) {
            addCriterion("city_id =", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotEqualTo(Integer value) {
            addCriterion("city_id <>", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThan(Integer value) {
            addCriterion("city_id >", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("city_id >=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThan(Integer value) {
            addCriterion("city_id <", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThanOrEqualTo(Integer value) {
            addCriterion("city_id <=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdIn(List<Integer> values) {
            addCriterion("city_id in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotIn(List<Integer> values) {
            addCriterion("city_id not in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdBetween(Integer value1, Integer value2) {
            addCriterion("city_id between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("city_id not between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andAreaIdIsNull() {
            addCriterion("area_id is null");
            return (Criteria) this;
        }

        public Criteria andAreaIdIsNotNull() {
            addCriterion("area_id is not null");
            return (Criteria) this;
        }

        public Criteria andAreaIdEqualTo(Integer value) {
            addCriterion("area_id =", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdNotEqualTo(Integer value) {
            addCriterion("area_id <>", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdGreaterThan(Integer value) {
            addCriterion("area_id >", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("area_id >=", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdLessThan(Integer value) {
            addCriterion("area_id <", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdLessThanOrEqualTo(Integer value) {
            addCriterion("area_id <=", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdIn(List<Integer> values) {
            addCriterion("area_id in", values, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdNotIn(List<Integer> values) {
            addCriterion("area_id not in", values, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdBetween(Integer value1, Integer value2) {
            addCriterion("area_id between", value1, value2, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdNotBetween(Integer value1, Integer value2) {
            addCriterion("area_id not between", value1, value2, "areaId");
            return (Criteria) this;
        }
    }

    /* @mbggenerated */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * 对应数据库表 mall_group_buy
     *
     * @mbggenerated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}